What is a function in SQL? Create a function that returns stu_Name when passed stu_ID.

Question

Krishnapriya Rajeev · Answer

In SQL, a function is a piece of code that performs a specific task and can be called from within SQL statements. A function can accept input parameters and return a value.
To create a function in SQL that returns stu_Name when passed stu_ID, you can use the following syntax:
CREATE FUNCTION get_student_name (student_id INT) 
RETURNS VARCHAR(50) AS 
BEGIN  
DECLARE student_name VARCHAR(50);  
SELECT stu_Name INTO student_name FROM students WHERE stu_ID = student_id;  
RETURN student_name; 
END;
This function is called get_student_name and takes one input parameter
student_id of type integer. It returns a value of type VARCHAR(50), which is the name of the student whose ID matches the input parameter.
The function uses a local variable student_name of type VARCHAR(50) to store the name of the student retrieved from the database table
students based on the input parameter value student_id. Finally, the function returns the value of
student_name.
You can then call this function in a SQL statement like this:
SELECT get_student_name(12);
This will return the name of the student with ID 12.

forum

What is a function in SQL? Create a function that returns stu_Name when passed stu_ID.

Revati S Misra

Can you answer this question?

1 Answers

Liked By